package com.wxxymaker.model.dao;

import com.wxxymaker.model.entity.DeletedStageCount;
import com.wxxymaker.model.entity.Shop;
import com.wxxymaker.model.entity.Stage;
import com.wxxymaker.model.entity.StageCount;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @Author: Soft
 * @Date: 2018/5/3 23:16
 * @Desc:
 */
public interface DeletedStageCountDao extends JpaRepository<DeletedStageCount, Integer>, JpaSpecificationExecutor<DeletedStageCount> {

    @Query(value = "select stage_id, stage_name from t_deleted_stage_count group by stage_name", nativeQuery = true)
    List<Object[]> findStageNames();

}
